Line and stacked column Visual - Age Group 17
Visual 1: Line and stacked
column Visual = Sales Per Month/YoY/GPM by Age Group
Fields Tab
Ø Shared
Axis: Age_Group
Ø Column
Values: Sales Per Month
Ø Line
Values: YOY%/GPM
Format Tab
Ø General:
X Position = 205, Y Position = 55, Width = 517, Height 327
Ø Legend:
On, Position = Top, Title = On, Color = #605E5C, font family = Segoe UI, Text
size = 10, Style = Markers Only
Ø X
Axis: Color = #605E5C, Text Size = 9, Font family = Segoe UI, Minimum category
width = 20, Maximum Size = 25%, Inner Padding = 20%, Concatenate labels = On,
Title = Off
Ø Y
Axis : Position = Left, Scale Type = Linear, Start = Auto, End = Auto, Color = #12239E,
Text size = 9, Font family = Segoe UI Bold, Display Units = Auto, Value Decimal
places = Auto, Title = Off, Secondary = On,
Align zeros = off, Y Axis (line): Position = Right, Start = Auto, End = Auto,
Scale type = Linear, color = #BF9D02, text size = 9, font family = Segoe UI (Bold),
Display units = Auto, Title = Off
Ø Data
Colors, YoY% = #E66C37, GPM = #D9B300, Default Color = #12239E
Ø Data
Label = On, Color = #000000, Display Units = Auto, Value Decimal places = Auto,
Orientation = Horizontal, Position = Auto, Text Size = 9, Font Family = Segoe
UI, Show Background = On, Background Color = #FFFFFF, Transparency = 30%
Ø Shapes:
Shade area = On, Stroke width = 3, Join Type = Round, Line Style = Solid, Show
marker = Off
Ø Title
= On, Title Text = Age_Group, Word wrap = On, font color = #000000, Background
color = #CCCCCC, Alignment = Center, Text Size = 14, Font Family = Segoe UI Bold
Ø Background:
On, color = #E6E6E6, Radius = 0
Ø Border:
Color = CCCCCC
Ø Shadow:
Off
Ø Tooltip
= On, Type = Report Page, Page = Auto, Label Text color = #C8C8C8, Value text
color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background color =
#333333, Transparency = 5%
Ø Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #333333, Visual information icon = On, Visual warning icon = On, Drill on drop down = On, Drill up icon = On, Drill down icon = On, Show next level icon = On, Expand to next level icon = On, Pin icon = On, Focus mode icon = On, Filter icon = On, See data layout icon = On, More Options icon = On
Step 2
Step 3
Step 4
Step 5
Line and Stacked Column Chart in Power BI
https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/